-
Can you have more than one Admin on WorkApps similar to Control Center?
Currently I cannot find a help article or a way to add a user as an admin to my WorkApps. The only option I see is to Transfer Ownership. I need to be able to allow backup users to modify allowed use…2 · -
Re: Calculating elapsed time in percentage #UNPARSEABLE
This should work: =IF(OR(ISBLANK([Start date]@row); ISBLANK([End date]@row)); "";IF(TODAY() < [Start date]@row; "Not Yet";IF(TODAY() > [End date]@row; "100%";(TODA…1 · -
Re: Counting rows that contain specific years
@RebTrachs This should do it. You need the IFERROR() to catch any blank cells since we are using a range and the @cell value. =COUNTIF([Start Date]:[Start Date], IFERROR(YEAR(@cell), 0) = 2023)3 · -
Re: If column has star, then return row name under primary column
@AnonUser1 Assuming that you only have to check one value for one row, as this is the only way this can work... For your Sheet Summary field, you will need to use an IF() formula to check the status …1 ·